CREATE TABLE [dbo].[JOL_EmailManagement_Sender]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[Admin_LoginID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[sender] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[smtpaddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[emailaddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[is_default] [bit] NULL,
[add_time] [smalldatetime] NULL,
[update_time] [smalldatetime] NULL,
[user_add] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[user_update] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_EmailManagement_Sender] ADD CONSTRAINT [PK_JOL_EmailManagement_Sender] PRIMARY KEY CLUSTERED  ([id]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'添加时间', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'add_time'
GO
EXEC sp_addextendedproperty N'MS_Description', N'登录用户的ID', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'Admin_LoginID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'发件邮箱地址', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'emailaddress'
GO
EXEC sp_addextendedproperty N'MS_Description', N'是否默认', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'is_default'
GO
EXEC sp_addextendedproperty N'MS_Description', N'发件邮箱密码', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'password'
GO
EXEC sp_addextendedproperty N'MS_Description', N'发件人', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'sender'
GO
EXEC sp_addextendedproperty N'MS_Description', N'smtp服务器', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'smtpaddress'
GO
EXEC sp_addextendedproperty N'MS_Description', N'更新时间', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'update_time'
GO
EXEC sp_addextendedproperty N'MS_Description', N'添加账户', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'user_add'
GO
EXEC sp_addextendedproperty N'MS_Description', N'更新账户', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'user_update'
GO
EXEC sp_addextendedproperty N'MS_Description', N'发件邮箱账户名', 'SCHEMA', N'dbo', 'TABLE', N'JOL_EmailManagement_Sender', 'COLUMN', N'username'
GO
